Share via

Upload files to Teams' team channel using Graph from VBA in Excel with Library 'Request check out'

Inácio Rodrigues 0 Reputation points
2024-05-13T13:33:45.0833333+00:00

I have an Excel file running some VBA code. This file is to be accessed and edited by my co-workers, so I share it in a channel in a Teams' team.

This file, upon some choices and inputs on a kind of form inside it, automatically generates some other files based on Word templates, creates some folders on the Teams' team channel, and uploads those files to there. It uses Graph to do this and I have it working perfectly.

The problem is that when I changed the Library settings for the team to 'Request check out' (I needed to avoid more than one user at a time using the Excel file), the generated files stopped being uploaded! This is even stranger since the folders are still created on the channel. Only uploading stopped working.

This is for sure related with the 'Request check out' feature, since if I turn off this option, everything gets back to normal.

Am I missing some Permission for my Graph/Azure app? Any hint how to solve it?

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,261 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,873 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiweiTian-MSFT 14,945 Reputation points Microsoft Vendor
    2024-05-14T02:14:38.8033333+00:00

    Hi @Inácio Rodrigues

    Based on our research, this appears to be behavior by design. While you check out a file, others cannot see your changes or edit the file. While this is helpful while you are making changes, it may also prevent others from performing their assigned tasks.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.